SUMMARY

• A results driven software professional with 8+ years of progressively responsible experience inData Analysis,Design,Implementation,Administration and Support of Business Intelligence,OLTP (Batch Processing, Online Processing),OLAP, ETL, Data warehousing, Data mining, DBMS and Data Modeling using Confidential SQL Server 2012/2008R2 /2008/2005,SSIS,SSRSandSSAS.
• 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 noledge ofData Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modeling and reporting tools.
• Experience in creatingViews, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scriptsand numerousstored procedureconsumed at various stages ofmigration/cleansingprocess,reportsordata validation.
• Proficient in writing complexT-SQL (DDL, DML),newfeatures likeCTE, Ranking Functions, TOP(n), PIVOT, XML PATH,SQL,Physical, logical database designand Performance tuning.
• Expertise inPower 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 designingSSISpackages to import and transform data between databases and external data sources using various transformations.
• Experience in configuration and maintain Report Manager andReport ServerforSSRS,DeployedandScheduledthe Reports inReport Manager
• Developed 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 inAd-hocreports, data driven subscription reports by usingReport Builder.
• Experience in developingDashboard Report, ParameterizedReports,Linked reports,Sub reportsby Region, Year, Quarter, Month and Week.
• DevelopedU-SQL scriptsfor processing massive amounts of data in a very familiar environment which is mainly used forAZURE DATA LAKE ANALYTICS.
• Worked on creatingAzure Data Factoryfor moving and transforming the data.
• Worked withAzure Data Lake Storeto capture data of any size, type, and ingestion speed in one single place for different operations
• Experience inMigrating databasesfromSQL 2008 R2 to SQL 2012.
• Experienced in all facets of Software Development Life Cycle (Analysis, Design, Development, Testing and maintenance) usingWaterfallandAgile methodologies.

TECHNICAL SKILLS

Databases: Confidential SQL Server (2005/2008/2008 R2/2012), Oracle 8i/9i, Oracle 10g/9i DB2,Postgre MS Access, NoSql Databases(Hbase).

DatabaseTools: 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 BI

Languages: VB.net, Linux, Unix

ETL 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

PROFESSIONAL EXPERIENCE

Confidential, Stamford, CT

Sr. SQL Server BI/ Power BI Developer

Responsibilities:

• DevelopedPowerBImodel used for financial reporting of P & L and Headcount.
• Designed and documented the entire Architecture of Power bi Poc
• Expertise in writing complex DAX functions inPower BI and Power Pivot.
• AutomatedPowerQuery refresh usingpowershell script and windows task scheduler.
• Used various sources to pull data intoPower BI such as Sql Server, SAP BW, Oracle, SQL Azure etc.. .
• Installed and configured Enterprise gateway and Personal gateway in Power bi service.
• Created Workspace and content packs for business users to view the developed reports.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.
• Weekly presentation to the business users about the reports and their changes as required.
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
• Worked on all types of transformations dat are available in Power bi query editor
• Created stored procedures and SQL queries to pull data intopowerpivot model.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Database creation(DDL, DML, DCL), database tuning, SQL tuning, performance planning.
• Extensively usedJoins and Sub-Queriesto simplify complex queries involving multiple tables.
• Developed tabular queries for efficient analysis of report usingPivot/Un pivotinT-SQL.
• Transformed complex business logic into Database design and maintaining it by using SQL objects likeStored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
• Creating and Modifying Tables,Stored Procedures, Views,Indexes, User-defined Functions, andTriggersas required.
• Created Jobs Performance report dat queries system tables to track the duration of each job and weekly-average duration usingSSRS.
• Designed and created data extracts, supporting SSRS, POWER BI, Tableau or other visualization tools reporting applications.
• Creating data blending in case of merging two different datasets usingTableau
• Created Datasets in T-SQL, stored procedures for SSRS.
• Developed Excel PowerView, PowerQuery and PowerPivot dashboards for data analysis
• Developed confidential proprietary analytical tools and reports with Confidential Excel, and Power Pivot and Power Point.
• Performed Index analysis for tables and came up with more efficient solutions to useClusteredandNon-Clustered Indexesfor significant performance boost using index tuning wizard.
• CreatedSSISpackages to import data fromAccess,Excel, XML, OLE DB Source and Flat Files.
• Filtered bad data usingDerived column, Lookups, Fuzzy Lookups,Conditional split.
• DesignedSSISpackages to import and transform data between databases and external data sources using various transformations likeData conversion,File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task.
• Designed and created data extracts, supporting SSRS, Power BI, Tableau or other visualization tools reporting applications.
• Debugging SSIS packages, Performance tuning onSlowly running SSIS Packages.
• Configure and maintain usingReport ManagerandReport ServerforSSRS,DeployedandScheduledthe Reports inReport Manager
• Created Reports usingCharts,Gauges,Tables,matrix.
• CreatedParameterized Report,Dashboard Report,Linked reportandSub Report by Year, Quarter, Month, and Week.
• CreatedDrill Down Reports, Drill Through Reportby Region.

Environment: Power BI,SQL Server 2012, SSMS, SSIS, SSRS, SSAS, Pentaho, T-SQL, Tableau, Power BI, Windows 7, MS Word, MS Excel, C#, Visio, Share Point Jira, SQL Profiler

Confidential, Atlanta,GA

Power BI Developer

Responsibilities:

• Worked closely with various teams across the company to identify and solve business challenges.
• Gathering and Analyzing requirements of clients, understand and convert them into database solutions with solid exposure to architecture, analysis, design, testing, development, deployment, documentation & implementation.
• Import data from different data sources to create Power BI reports and Dashboards.
• Experience in developing Reports, Charts, Dashboards using Power BI Desktop and manage security based on requirements
• Transform, define, navigate the data from data source and performed merge and append queries using Power Query.
• Implemented complex query techniques of passing Multi-Valued parameters and cascading parameters in MDX.
• Performed transformations like Pivoting, Unpivoting and Splitting of the columns using Power Query.
• Created different chart types and drill down reports using Power Bi Desktop (SSRS).
• Involved in defining report layout in SSRS.
• Created measures, calculated columns, relationships and performed time series analysis using DAX in Power BI
• Published reports and visualizations to Power BI Service and theirby created dashboards.
• Created hierarchies in Power BI reports using visualizations like Bar chart, Line chart, etc.
• Worked with both live and import data into Power BI for creating reports.
• Managed relationship between tables in Power BI using star schema.
• Used different type of slicers available in Power BI for creating reports.
• Experienced in creating many dashboards by pinning many visualizations in the workspace as per the insights provided.
• Experienced in Data Modeling used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Experience in developing several Details, Summary reports including line and pie charts, trend analysis reports and sub-reports per business requirements.
• Experience in generating on-demand and scheduled reports for business analysis or management decision.
• Used recently introduced Power BI to create self-service BI capabilities and use tabular models.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Shared the created workspace across the organization using PowerBI Apps.
• Responsible for creating Row-Level Security (RLS) based on the business requirements.

Environment: s: Power BI, DAX, Power BI Gateway, Power BI Apps, MDX, MS SQL Server 2016/2014/2012/2008 R2, MS Excel, JSON, Windows 8/10, JIIRA, SSRS, SSAS

Confidential, Bethpage, NY

Power BI Developer

Responsibilities:

• Worked with Project team to outline Project requirements.
• Gathering and Analyzing requirements of clients, understand and convert them into database solutions with solid exposure to architecture, analysis, design, testing, development, deployment, documentation & implementation.
• Profiled the legacy database tables to provide data cleansing issue reports to the client.
• Developed data reconciliation SQL queries to validate the overall data migration
• Formulated DAX Expressions create Date to yearly columns and implemented partitions in Tabular Models for Power BI.
• Created measures, calculated columns and performed time series analysis using DAX in Power BI
• Effectively used data blending, filters, actions, and hierarchies feature in Power BI.
• Analyzed the data using Statistical features in Power BI to develop trend analysis and published the reports on the Power BI Services.
• Created different chart types and drill down reports (SSRS)
• Participated in the configuration of on-premises Power BI gateway to refresh datasets of Power BI reports and dashboards .
• Implemented complex query techniques of passing Multi-Valued parameters and cascading parameters in MDX.
• Involved in defining report layout in SSRS. Created complex stored procedures for reporting services and Analyzed reports
• Generated several daily and monthly critical reports
• Created and maintained several ETL jobs and resolved any issues associated with the jobs
• Developed and maintained SSIS Packages to integrate with different resources like MySQL, Oracle, SQL Server, Teradata, Flat files.
• Performed several performance tunings using execution plan and SQL profiler to improve the performance.

Environment: s: Power BI, DAX, MS SQL Server 2016/2014/2012/2008 R2, SQL, Team Foundation, JIIRA, MS Excel, CSS, SSRS,SSIS

Confidential, Madison, NJ

SQL BI Developer (SSIS/SSRS)

Responsibilities:

• Designed, deployed, and maintained various SSRS Reports in SQL Server 2005
• Created Sub-Reports, ad-hoc reports, Drilldown-Reports, Summary reports, and Cross Tab reports
• Actively participated in gathering Business Requirements dat are focused on providing a user friendly System usage or ambience
• Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance
• Used differentControl Flow Tasks and Data flow Taskfor Creating SSIS Packages. Used different types ofTransformationsfor Data Conversion, Sorting and cleaning the data from different Sources into Company Format
• Created SSIS packages to download data from FTP sites and populating into different databases and tables.
• Created Drill down and drill through reports in SSRS.
• Expertise in scheduling reports to end-users and give acess to the report server.
• Created Subscriptions such as standard and data driven in Report Manager SSRS to generate email notifications.
• Developed and scheduled the cached reports in SSRS
• Created SSIS packages to import data from MS Access, Excel to SQL 2008R2
• Optimized the query performance with modification in T-SQLqueries, removing unnecessary columns, eliminating redundant and inconsistent data.
• Effectively created and used views in SQL Server to prevent unauthorized access
• Performed tuning of databases by normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.
• Developed and created the new database objects including tables, views, indexes, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer
• Worked oncomplex data loading(implemented the batch data cleansing and data loading
• Meeting with Business Analyst and data modelling team to understand requirements and existing
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard
• Data conversion from Text File into SQL Server Table and Database recovery and database maintenance plan
• Assisted in designing and implementing database logical and physical schemas and document the testing and maintenance of system corrections

Environment: SQL Server 2008R2, SQL Services Integration Services 2008R2, T-SQL, XML, MS SQL Reporting Services 2008R2, SQL Profiler, MS Office, DB2, Windows Server 2008.

Confidential, Aloha, OR

SQL Developer

Responsibilities:

• Involved in system analysis & design of the Enterprise data warehouse implementation,Requirementsgatheringandunderstandingthe business flow.
• Designed theFunctional Requirements andMapping Technical Specificationson the basis ofFunctional Requirements.
• CreatingIndex, Views, Complex Stored Procedures, Triggers, Cursorsand appropriateUser defined functionsto implement the business logic.
• Creation of database tables and procedures to update and clean the old data.
• Transferred data fromflat files,Excel spreadsheets, and XML Sourcedata to SQL Server usingSSISand also used BCP and Bulk Insert.
• Designeddashboards,including scorecards and reporting with theDashboard Designer delivered via MOSS ( Confidential Office SharePoint Server).
• Involved in data modeling for the application and created ER diagram using Erwin.
• Created, Maintained & scheduled various reports inSSRSlike Ad-hoc Reports, Canned Reports, and Master Reports & Parameterized Reports, Drill Down Report, Drill Through Report usingSQL Server Reporting Services SSIS 2005.
• Proficient on and designing Data Mart and Data Warehouse usingErwin in Star and Snowflake Schemas.
• Helped Database administrators with power shell in building robust administration scripts.
• Responsible for support of MOLAP structures using Analysis Services 2005 and reporting structures in MS EXCEL and Reporting Services 2005.
• Designed and MaintainedSSISPackages for Importing and Exporting Data Migration and Conversion fromLegacy Systems to SQL Server 2005.
• UsedSSRSto create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports inSSRS.
• Created document for Self-Service Deployment and Execution process forSSISpackages
• Interacting with the users and troubleshooting the problems involved with the development ofstored Procedures, triggersandproblemsrelated to the privileges.
• Responsible to tuneETLprocedures and schemas to optimize load and query Performance.

Environment: SQL Server 2005, MS Access, SSIS, SSRS, Query Analyzer, ERWIN, Windows server 2003, DTS, T-SQL, SQL Profiler, DTS