Please Share Profile - dhira...@idctechnologies.com <rox.realdhi...@gmail.com>
*Role: Power BI Consultant * *Job Location: Charlotte, NC* *Duration: 12+ Months* *Interview: Telephonic/Skype* *Must Have:* · Ability to work with various types and stages of Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation. · Skillful in ETL - Extraction Transformation Loading, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies. · Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modeling and reporting tools. · Experience in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts and numerous stored procedure consumed at various stages of migration/cleansing process, reports or data validation. · Proficient in writing complex T-SQL (DDL, DML), new features like CTE, Ranking Functions, TOP(n), PIVOT, XML PATH,SQL, Physical, logical database design and Performance tuning. · Expertise in Power BI, Power BI Pro, Power BI Mobile. · Expert in creating and developing Power BI Dashboards in to rich look. · Knowledge in all types of Database migrations with all the versions of SQL Server. · Expertise in designing SSIS packages to import and transform data between databases and external data sources using various transformations. Experience in configuration and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report ManagerDeveloped OLTP system (s) and involved in creating facts, dimensions and Star Schema representation for the data mart. · Expertise in OLAP and OLAP Cubes in SSAS.Experience in Ad-hoc reports, data driven subscription reports by using Report Builder. · Experience in developing Dashboard Report, Parameterized Reports, Linked reports, Sub reports by Region, Year, Quarter, Month and Week.Developed U-SQL scripts for processing massive amounts of data in a very familiar environment which is mainly used for AZURE DATA LAKE ANALYTICS. · Worked on creating Azure Data Factory for moving and transforming the data. · Worked with Azure Data Lake Store to capture data of any size, type, and ingestion speed in one single place for different operations · Experience in Migrating databases from SQL 2008 R2 to SQL 2012.Experienced in all facets of Software Development Life Cycle (Analysis, Design, Development, Testing and maintenance) using Waterfall and Agile methodologiesDatabases: Confidential SQL Server (2005/2008/2008 R2/2012), Oracle 8i/9i, Oracle 10g/9i DB2,Postgre MS Access, NoSql Databases(Hbase). · Database Tools: MS SQL Server (2005/2008/2008 R2/2012), MS-Access, SQL Server Integration Services(SSIS), Data Transformation Services(DTS), SQL Server Reporting Services(SSRS) Development skills: · T-SQL, PL/SQL, SSIS/SSRS, SQL PLUS, Power BILanguages: VB.net, Linux, UnixETL Tools: DTS, SSIS (SQL Server Integration Services), Informatica, COMOS, Kettle Reporting Packages: · SQL Server Reporting Services, MS Excel.Tools/Methodologies: MS Project, SQL Profiler, Toad, TFS 2010, Agile, Jira, Waterfall. · Operating Systems: Windows XP, Windows 7,Windows 8, Win 2003/2008/2008 R2 Regards, *Dhiraj Kumar* *Account Manager* *IDC Technologies.* *Direct: *408-819-2770 *Mailto: *dhira...@idctechnologies.com -- You received this message because you are subscribed to the Google Groups "CorptoCorp" group. To unsubscribe from this group and stop receiving emails from it, send an email to corptocorp+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/corptocorp/CALn2kdbAy7%3Dht7roRscGAqo17eZAJJ-Um3GFP8HtYOHfh%3Dvr7Q%40mail.gmail.com.
