SUMMARY:

• 9 (Nine) 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 2008/2012/2014
• Experienced SSRS Developer with experience working on large - scale enterprise projects involving complex business case functions, web integration, and data management.
• Extensive experience in SSAS
• Created SSIS jobs and packages and executed those 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
• 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:

Software/Hardware: 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,, Visual Studio 20012,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, Deere Field, FL

SQL BI Developer

Responsibilities:

• Migrated SSIS packages from SQL Server 2008 to SQL Server 2012 asSSISPackages
• 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 usingSSISpackages.
• Used various Data Flow Transformations like Lookup, Union All, Multicast, Cache Transform, and Conditional Split while developing the packages.
• DevelopedSSISPackages 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 UsingSSISfor 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).
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
• Transferred data from various sources using SSIS and then created reports using this data usingSSRS.
• 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.
• 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-SQLin Development environment forSql 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

Confidential, Alpharetta, GA

SQL BI Developer/Admin

Responsibilities:

• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.
• 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.
• 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.
• 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 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

S apient, Atlanta, GA

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