SUMMARY:

• Over Ten years of experience on Software Systems analysis/ design/ development/ testing/ performance optimization and documentation.
• Design, deployment, and maintenance of various Reports in SQL Server 2012
• Extensive Knowledge in SSRS/SSIS 2008/2012/2014
• Experienced SSIS/SSRS/SSAS Developer with experience working on large - scale enterprise projects involving complex business case functions, web integration, and data management.
• Extensive experience in creating SSIS jobs and packages and executing the tasks.
• Proficient in using Crystal Decision, Crystal Management Console, Crystal Configuration Manager, Crystal Repository, Crystal Migration Wizard and Crystal Publishing Wizard for publishing reports on the Intranet.
• In-depth knowledge in working and implementation of Crystal Decisions & Crystal Reports 7.0/8.0/9.0/10/ XI.
• Strong experience in T- SQL development with MS- SQL
• Expert in designing and developing Tabular models.
• Implemented Role based and user based subject selection in Tabular models.
• Expert in DAX functions.
• Experience in Creating, Modifying Measures, Dimensions Attribute relationships and Hierarchies.
• Experience on performing Data loads to Dimension, Fact tables, Data warehouse, Data marts, and OLAP cubes.
• Extensive experiences in developing Stored Procedures, Views, Triggers, XML and Complex Queries on SQL Server 2005/2008/2012
• Highly motivated, reliable analytical problem solver and troubleshooter with strong attention to detail.
• Possess excellent written and oral communication skills with a result-oriented attitude
• Exposed to each of the phases of Software Development Lifecycle (SDLC) and experienced to work as a team member as well as an individual performer under the large development groups.
• Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.
• DTS applications moving data between different types of databases and legacy systems
• Experienced in data modeling tools, e.g., Erwin.
• Capable of working under Pressure and reach milestones.

TECHNICAL SKILLS:

• MS SQL Server 2008/12
• MS Reporting services 2005/2008/2012
• SharePoint 2007 /2013 Crystal Reports 9.0 / 10 / X1
• Crystal Enterprise Manager X1 R2
• Central management console
• SQL Analyzer
• VisualStudio20012
• SSRS
• SSAS
• SSIS
• SQL Enterprise Manager
• Erwin
• Oracle Developer2000 (Forms and Reports)
• Oracle Tools and Oracle Utilities
• PL/SQL
• SQL Plus
• Oracle 9i Application Server
• Oracle Procedure Builder
• TOAD 6.0
• Microsoft Products (MS Word
• MS Excel
• VSS
• MS Access
• MS Power Point
• MS Project)
• HTML.

PROFESSIONAL EXPERIENCE:

Confidential, Sandy Springs, GA

SQL BI Developer

Responsibilities:

• Responsible for the smooth flow of data from different data sources to velocity databases.
• Creating SSIS packages and updating the existing ones for resolving the issues and adding the new functionality upon the requirement.
• Handling replication configured on the system effectively and to make sure it run smoothly without any issues.
• Developing necessary windows command batch scripts for deployment of the automated builds for both issues and requirements.
• Handling different environmental issues that come up in different environments DEV, TEST, UAT.
• Design SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Design Dimensional model by analyzing all the requirements from the clients for the different source systems.
• Used OLAP cubes and wrote queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting service (SSRS)
• Involved in creation/review of functional requirement specifications and supporting documents for business systems.
• Extracting trade data from Web API to XML files and then pushing into Staging area.
• Created a virtual machine on Azure, installed SQL 2014, created and administered databases then loaded data using SSIS
• Schedule the packages to keep extracting the data from OLTP at specific time intervals.
• Created various Power BI Reports that includes Charts, Filters, Scorecards, Drilldown and Drill-Through, Cascade, Parameterized reports that involved conditional formatting.
• Mentored business power users to create reports/dashboards using PowerBI.

Environment: Microsoft SQL Server 2014, SQL Server Integration Services SSIS 2014, SQL Server Reporting services SSRS 2014, SQL Server Analysis Services SSAS, ASP.net, Excel 2013, Azure, Power BI, Tableau

Confidential, Alpharetta, GA

SQL BI Developer

Responsibilities:

• Developed new tabular data models for different subject areas, Power BI dashboards and Analytic charts
• Used T-SQL views, stored procedures, CTEs and sub queries concepts for creating objects for tabular model
• Created dimensional model using Power Pivot and created power pivot charts
• Updated existing SSRS Reports following changes in business requirements
• Presented Analytics Solutions, Dashboards to Executive management on demand.
• Configured Share Point central administration content database, site documents, list data, web part properties, data for apps for share point, user names and permissions
• Worked with Share Point products configuration wizard
• Experience working with SSRS in share point integrated mode and worked with share point content, configuration, Report server and Report server temp databases.
• Created, modified, schedule and deploy SSRS Reports/Database scripts
• Created and updated Database objects, scripts, indexes and perform query and Performance tuning used by reporting services.
• Created and maintained Table partitions, database backups, database refresh in coordination with DBA
• Extract data from SharePoint document library and load into Azure SQL server
• Create PowerPivot models and PowerPivot reports, publish reports onto SharePoint, and deploy models into SQL Server SSAS instance.
• Create Parameterized SSRS Reports and PowerPivot Workbooks using data of Tabular model and Cube data model to prove the functionality of database
• Under immediate supervision, designs, modifies, writes, and implements software programming applications. This includes configuring, coding, developing, and documenting software specifications throughout the project life cycles
• Coordinated Database user and security permissions in line with Corporate Standards
• Deployed SSRS reports to SharePoint and managed subscriptions and security
• Experience partitioning for optimized processing and secured to the row-level by using role based security
• Regular interaction with GDS (offshore) Team

Environment: Microsoft SQL Server 2012, SQL Server Integration Services SSIS 2012, SQL Server Reporting services SSRS 2012, SQL Server Analysis Services SSAS 2012, ASP.net, Excel 2013, Power BI,Spotfire

Confidential, DeerField, FL

SQL BI Developer

Responsibilities:

• Migrated SSIS packages from SQL Server 2008 to SQL Server 2012 as SSIS Packages
• Working in Agile Methodology tracking the product backlog and resolved the defects assigned in daily scrum.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Used various Data Flow Transformations like Lookup, Union All, Multicast, Cache Transform, and Conditional Split while developing the packages.
• Developed SSIS Packages using Look Up Values & implementing rules provided by Business in the mapping document.
• Worked on managing ETL process by pulling large volume of data from OLTP to a staging Database Using SSIS for Data transformation
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
• Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).
• Identified the potential Issues that occur during the package execution by redirecting the rows from source component to Error Output.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2012
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Worked on Cube to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations Transferred data from various sources using SSIS and then created reports using this data using SSRS.
• Worked on creating Cell Level Security in cubes using SSAS.
• Worked on creating Perspectives, Partitions and Design Aggregations in cubes using SSAS
• Expert in creating Power pivots, Power views and SSRS reports using tabular model (DAX), Cubes (MDX) and SQL queries
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Used reporting objects like Tabular, Matrix, Sub Reports, Parameterized reports using SSRS 2012.
• Used SSAS for deploying the tabular mode cube for analysis purpose.
• Used Dimensional Modeling technique, Multi-Dimensional Database Schemas like Star, Snowflake Schema, Fact and Dimensional tables
• Created usage based aggregations in cube to minimize time for query retrieval from client tool Target.
• Created and modified various Stored Procedures used in the application using T-SQL.
• Created new database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in Development environment for Sql server 2012.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent.
• Creation of user Databases, managing security and created stored procedures.
• Handled the database components (Code migration, Change control) for application releases.
• Develop BI strategies and roadmaps in alignment with the organization's goals and translate them in to structured plans for evolving business capabilities with actionable insights.
• Improved Report Performance and performed unit testing

Environment: SQL Server 2012, Windows 7, Windows Server 2012, SSIS, and SSRS, SSAS, Visual Studio 2012, JIRA, SSMS, Tableau, Power BI

Confidential, Alpharetta, GA

SQL BI Developer/Admin

Responsibilities:

• Supported Batch and Online processes involving development, enhancement and support of T-SQL procedures, views, triggers and query tuning.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic
• Developed and performed data modeling studies, support data selection, extraction and cleansing of mediation applications.
• Developed SSIS ETL packages to meet data flow needs.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads.
• Created Parameterized reports and Linked reports and thorough knowledge of report serving architecture using SSRS.
• Worked with SSAS cube to define dimension, facts, attribute hierarchy & user defined hierarchy.
• Extensively involved in replication and implemented Snapshot, Merge and Transactional Replications.
• Developed SSIS ETL Packages to meet data flow needs & building platform with the using of SSIS.
• Created SSIS Packages using the concepts of incremental loading and slowly changing dimensions
• Managed source code, keeping track of project deliverability such as defects, requirements, tasks & versioning control with the using of Team Foundation Server.
• Used Index usage statistics to determine how useful an index is and if an index is improving or hindering application performance.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2005/08R2 for further Data Analysis and Reporting by using multiple transformations, scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Created reports from the OLAP cubes using SSRS.
• Also implemented user based subject selection (Role based security) in Power Views, Power Pivots and SSRS using DAX, MDX and SQL queries.
• Enhanced performance of databases using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
• Supported Application Development team with any database issues, updates or new releases and deadlock issues, best practices in structuring T-SQL Queries, debugging

Environment: MS SQL Server 2008/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MDM(Master Data Management)Business Intelligence Development Studio (BIDS), SharePoint 2013, MS Excel, Windows XP, Crystal Reports, Business Objects .

Confidential, Atlanta, GA

SQL BI Developer

Responsibilities:

• Responsible for new database design and implementation
• Created Database Objects - Tables, Indexes, Views, and Roles
• Created complex store procedure to copy Database Objects from remote server to local machine and vice versa
• Responsible for monitoring and tuning T-SQL performance
• Fine tuned database objects and server to ensure efficient data retrieval
• Responsible for migration of SQL objects to production from test environment
• Responsible for planning and designing of SSIS package for data refresh purpose
• Create new and improve existing database reports using SQL Reporting Services 2005
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases
• Created SSIS jobs and packages and executed those tasks
• Created reports with different type of properties like chart controls, filters, SQL parameters etc
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Actively supported business users for change requests.
• Identified and defined datasets, added parameters for the report generation and wrote the queries for the drill down reports.
• Provide required reports from production environment to other departments on request basis and perform data analysis to provide management
• Modified report content and export reports in multiple formats based on user input
• Created numbers of complex formula in sub report using different type of variables likes shared variable and retrieved them from master report
• Designed, developed, modified and enhanced the database structures and database objects
• Updated project status reports/created issue items for reviews/updated technical and transformation files on timely basis.
• Created sites in MS Sharepoint server 2007 according to user requirements
• Created lists, Document folders alerts in MS Sharepoint server
• Deployed reports and managed data sources to the SSRS 2005 reports
• Responsible to send alerts and schedule reports is MS Sharepoint Server
• Responsible for unit testing of code designed in QA and Production.
• Planned, defined and designed data based on the business requirement
• Administrator and maintaining Microsoft Office SharePoint Server 2007 and Windows SharePoint Services 3.0/2.0 including customer support and ongoing development.
• Configured MOSS Server Farm and created Web Applications, Site Collections and Sites.
• Installation and setup of the environment of MOSS 2007, Configuration and Maintenance of SharePoint Farm through Central Administration, Configured MOSS Site template based on business requirements
• Created customized workflows in Sharepoint designer according to user requirement.
• Created Stored Procedures, views in SQL Server using T-SQL to collect data for the crystal reports
• Developed and implemented procedures to ensure the quality, usability and accuracy of reports
• Created Packages to group logically related column types and to transfer data

Environment: SQL Server 2008, SQL Integration Services, SQL Server Reporting Services, MS SharePoint Server 2007,MS SharePoint Designer, Crystal Reports XI

Confidential, Seattle

MS SQL Server / SSIS /SSRS Developer/SharePoint Administrator

Responsibilities:

• Analyzed CRD and CVO (Historical MS Access Databases) and documented
• Created several prototypes using MS Access
• Created SQL server Reports using SSRS 2005
• Created different levels of drill down charts
• Wrote Different types of Expressions to created complex reports
• Wrote different complex SQL queries
• Created SSIS jobs and packages and executed those tasks
• Used SSAS cubes and created parameterized reports
• Created different shared data sources and connected the reports to data sources
• Created Dynamic Drill Down reports
• Created Parameterized and Cascading parameterized reports
• Created matrix reports, drill down reports and developed reports with graphs
• Used Common functions like Aggregate, financial, Date time etc in Development of reports
• Involved in Sharepoint user management such as configuring user permission level and various users group permissions and adding users accordingly.
• Well versed with List, Views, Web Parts, Configuring workflows, Content Type, Site Columns etc.
• Involved in planning for Back-Up System/Disaster recovery, well versed working with STSADM Commands.
• Experience in deploying Features and Solutions in SharePoint.
• Proficient at workflows using the out-of-the-box or custom designed using SharePoint Designer 2007.
• Configured out-of-the-box and custom web parts to interact with MOSS 2007 lists, libraries, BDC and other data sources.
• Wrote .NET embedded code for custom constants
• Wrote .NET code and handled the custom functions
• Deployed reports to the report server and managed the reports
• Developed windows schedule tasks for different data pulls and directly populate data to SQL Server by creating several ODBC connections
• Used XML for exchanging information in different modules of the application
• Managed documents and records using Sharepoint ECM
• Created several test cases and involved in system testing
• Responsible to provide production support to the client
• Created different tasks and Work Flows for direct data pulls from DB2 to SQL Server by using Informatica 8.1 tools

Environment: MS SQL Server 2005/2008, SSIS,SSAS, SSRS, XML, Windows Server 2003, SharePoint Server 2007,DB2, MS Access 2003, Informatica 8.1, MS Office 2003

Confidential, New Jersey, NJ

SSRS/SSAS/SSIS/SharePoint Administrator

Responsibilities:

• Created SQL server Reports using SSRS 2005
• Created datasets and used them for development of reports
• Wrote Different types of Expressions to created complex reports
• Built the cubes and the time dimensions and edited the cube
• Created the calculated members and member properties
• Created the virtual dimensions
• Added roles to the cubes
• Defined the MDX calculations and sub-cube calculations
• Created Shared Data sources
• Developed data models to create Ad-hoc reports
• Created reports with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc
• Designed and implemented stylish report layouts
• Wrote complex expressions using operators like arithmetic, Comparison, Concatenation and Logical/ Bitwise
• Used embedded images in different types of the reports
• Wrote .NET embedded code for custom constants
• Scheduled Reports to run the reports Hourly, Daily, Monthly According to end user requirements
• Assigned Roles for users for security of the reports
• Used Business Intelligence Development Studio to build reports using the wizards and designers, and deploy them to Report Server
• Created Dynamic Drill Down reports
• Created matrix reports, drill down reports and developed reports with graphs
• Exported reports into multiple formats based on user input
• Created numbers of complex formula in sub report using different type of variables likes shared variable and retrieved them from master report
• Migrated WSS 2.0 to WSS 3.0 by using Quest Migration Manager
• Installed, Configured and Enabled Quest Migration Manager on WSS 3.0 IIS target server.
• Configured the database Server for Quest Management console for SharePoint 2.0.4
• Added server farm (SharePoint Front-end Server) for Migration Manager.
• Migrated content from WSS 2.0 Transition servers to target WSS 3.0 servers using Quest Migration Manager.
• Mapped source WSS 2.0 and Target WSS 3.0 farms and created individual Migration jobs for each site collection and run each Migration job.
• WSS 2.0 to WSS 3.0 sites migration has been stated on the WSS 2.0 site by applying a redirected message using Microsoft Office SharePoint Designer 2007
• Worked with alerts and discussion Boards in sharepoint
• Shared Documents in sharepoint
• Designed, developed, modified and enhanced the database structures and database objects
• Created different type of reports with Graphs
• Created Stored Procedures, views in SQL Server using T-SQL
• Developed and implemented procedures to ensure the quality, usability and accuracy of reports

Environment: MS SQL SERVER REPORTING SERVICES 2005, SSIS, SSAS,SQL Server 2005, SharePoint 3.0,ASP/ASP.Net, Visual Source Safe 2005, Visual Studio 2005